DROP TABLE CRUMBS_CATALOG_OF_TOOLS CASCADE CONSTRAINTS 
;
DROP TABLE CRUMBS_CATALOG_OF_WORK CASCADE CONSTRAINTS
;
DROP TABLE CRUMBS_REQUESTS_STATE CASCADE CONSTRAINTS
;
DROP TABLE CRUMBS_ADDITIONAL_TOOLS CASCADE CONSTRAINTS
;
DROP TABLE CRUMBS_REQUEST CASCADE CONSTRAINTS
;
DROP TABLE CRUMBS_DATE_AND_TIME CASCADE CONSTRAINTS
;
DROP TABLE CRUMBS_CLIENT CASCADE CONSTRAINTS
;
DROP TABLE CRUMBS_POSITION CASCADE CONSTRAINTS
;
DROP TABLE CRUMBS_USER CASCADE CONSTRAINTS
;
DROP TABLE CRUMBS_PROCESS_HISTORY CASCADE CONSTRAINTS
;
DROP TABLE CRUMBS_REQUEST_AND_WORK CASCADE CONSTRAINTS
;
DROP TABLE CRUMBS_REQUEST_ASSIGN CASCADE CONSTRAINTS
;
DROP TABLE CRUMBS_WORK_AND_TOOLS CASCADE CONSTRAINTS
;

drop sequence CLIENT_SEQUENCE;
drop sequence REQUEST_SEQUENCE;
drop sequence ADDITIONAL_TOOLS_SEQ;
drop sequence CATALOG_OF_TOOLS_SEQ;
drop sequence CATALOG_OF_WORK_SEQ;
drop sequence DATE_AND_TIME_SEQ;
drop sequence POSITION_SEQ;
drop sequence PROCESS_HISTORY_SEQ;
drop sequence REQUEST_AND_WORK_SEQ;
drop sequence REQUEST_STATE_SEQ;
drop sequence USER_SEQ;

CREATE TABLE  "CRUMBS_CATALOG_OF_TOOLS" 
   (    "ID" NUMBER(9,0) NOT NULL ENABLE, 
    "NAME" VARCHAR2(40) NOT NULL ENABLE, 
    "TOOLS_DESCRIPTION" VARCHAR2(1000), 
    "IS_DELETE" NUMBER(1,0) NOT NULL ENABLE, 
     CONSTRAINT "CRUMBS_CATALOG_OF_TOOLS_PK" PRIMARY KEY ("ID") ENABLE
   );

CREATE TABLE  "CRUMBS_REQUESTS_STATE" 
   (    "ID" NUMBER(9,0) NOT NULL ENABLE, 
    "STATE" VARCHAR2(15) NOT NULL ENABLE, 
     CONSTRAINT "CRUMBS_REQUEST'S_STATE_CON" PRIMARY KEY ("ID") ENABLE
   ) ;

CREATE TABLE  "CRUMBS_REQUEST" 
   (    "ID" NUMBER(9,0) NOT NULL ENABLE, 
    "DATE_OF_CREATION" TIMESTAMP NOT NULL ENABLE, 
    "CLIENT_ID" NUMBER(9,0) NOT NULL ENABLE, 
    "STATE_ID" NUMBER(2,0) NOT NULL ENABLE, 
    "REQUEST_INFO" VARCHAR2(500), 
    "ACTUAL_TIME_OF_WORK" NUMBER(9,0), 
     CONSTRAINT "REQUEST_PK" PRIMARY KEY ("ID") ENABLE
 );

CREATE TABLE  "CRUMBS_ADDITIONAL_TOOLS" 
   (	"ID" Number(9,0) NOT NULL ENABLE,    
	"REQUEST_ID" NUMBER(9,0) NOT NULL ENABLE, 
    "TOOL_ID" NUMBER(9,0) NOT NULL ENABLE, 
    "AMOUNT" NUMBER(5,0) NOT NULL ENABLE, 
     CONSTRAINT "CRUMBS_ADDITIONAL_TOOLS_UK1" UNIQUE ("TOOL_ID", "REQUEST_ID") ENABLE
 );

CREATE TABLE  "CRUMBS_CATALOG_OF_WORK" 
   (    "ID" NUMBER(9,0) NOT NULL ENABLE, 
    "WORK_DESCRIPTION" VARCHAR2(1000), 
    "RUNTIME" NUMBER(9,0), 
    "IS_PARENT" NUMBER(1,0) NOT NULL ENABLE, 
    "IS_DELETE" NUMBER(1,0) NOT NULL ENABLE, 
    "PARENT_ID" NUMBER(9,0), 
    "WORKNAME" VARCHAR2(40) NOT NULL ENABLE, 
     CONSTRAINT "CRUMBS_CATALOG_OF_WORK_PK" PRIMARY KEY ("ID") ENABLE
 );

CREATE TABLE  "CRUMBS_CLIENT" 
   (    "ID" NUMBER(5,0) NOT NULL ENABLE, 
    "NAME" VARCHAR2(40), 
    "ADRESS" VARCHAR2(100) NOT NULL ENABLE, 
    "MAIL" VARCHAR2(40) NOT NULL ENABLE, 
     CONSTRAINT "CLIENT_PK" PRIMARY KEY ("ID") ENABLE
 );

CREATE TABLE  "CRUMBS_DATE_AND_TIME" 
   (    "ID" NUMBER(9,0) NOT NULL ENABLE,
       "REQUEST_ID" NUMBER(9,0) NOT NULL ENABLE, 
    "DATE_BEGIN" TIMESTAMP NOT NULL ENABLE, 
    "DATE_END" TIMESTAMP NOT NULL ENABLE, 
    "ASSIGNED_TIME_BEGIN" TIMESTAMP, 
    "ASSIGNED_TIME_END" TIMESTAMP,
       CONSTRAINT "CRUMBS_DATE_AND_TIME_PK" PRIMARY KEY ("ID") ENABLE
       
 );

CREATE TABLE  "CRUMBS_POSITION" 
   (    "ID" NUMBER(1,0) NOT NULL ENABLE, 
    "NAME" VARCHAR2(30) NOT NULL ENABLE, 
    "FUNCTIONAL_REQUREMENTS" VARCHAR2(1000), 
     CONSTRAINT "CRUMBS_POSITION_PK" PRIMARY KEY ("ID") ENABLE
 );

CREATE TABLE  "CRUMBS_USER" 
   (    "USER_ID" NUMBER(9,0) NOT NULL ENABLE, 
    "LOGIN" VARCHAR2(60) NOT NULL ENABLE, 
    "PASSWORD" VARCHAR2(60) NOT NULL ENABLE, 
    "POSITION_ID" NUMBER(1,0) NOT NULL ENABLE, 
    "PHONE" VARCHAR2(20) NOT NULL ENABLE, 
    "ADDITIONAL_INFO" VARCHAR2(1000), 
    "SURNM_NM_SECONDNM" VARCHAR2(60) NOT NULL ENABLE, 
     CONSTRAINT "CRUMBS_USER_PK" PRIMARY KEY ("USER_ID") ENABLE
 );

CREATE TABLE  "CRUMBS_PROCESS_HISTORY" 
   (    "ID" NUMBER(9,0) NOT NULL ENABLE, 
    "FIXED_DATE" TIMESTAMP NOT NULL ENABLE, 
    "REQUEST_ID" NUMBER(9,0) NOT NULL ENABLE, 
    "COMMENT_TEXT" VARCHAR2(1000), 
    "RECIEVER_ID" NUMBER(9,0) NOT NULL ENABLE, 
    "SENDER_ID" NUMBER(9,0) NOT NULL ENABLE, 
     CONSTRAINT "PROCESS_HISTORY_PK" PRIMARY KEY ("ID") ENABLE
 );

CREATE TABLE  "CRUMBS_REQUEST_AND_WORK" 
   (   "ID" NUMBER(9,0) NOT NULL ENABLE,  
       "REQUEST_ID" NUMBER(9,0) NOT NULL ENABLE, 
    "WORK_ID" NUMBER(9,0) NOT NULL ENABLE, 
    "AMOUNT_OF_WORK" NUMBER(3,0) NOT NULL ENABLE,
       CONSTRAINT "CRUMBS_REQUEST_AND_WORK_PK" PRIMARY KEY ("ID") ENABLE
 );

CREATE TABLE  "CRUMBS_REQUEST_ASSIGN" 
   (    "REQUEST_ID" NUMBER(9,0) NOT NULL ENABLE, 
    "USER_ID" NUMBER(9,0) NOT NULL ENABLE
 );

CREATE TABLE  "CRUMBS_WORK_AND_TOOLS" 
   (    "WORK_ID" NUMBER(9,0) NOT NULL ENABLE, 
    "TOOL_ID" NUMBER(9,0) NOT NULL ENABLE
   );
ALTER TABLE  "CRUMBS_ADDITIONAL_TOOLS" ADD CONSTRAINT "CRUMBS_ADDITIONAL_TOOLS_FK" FOREIGN KEY ("REQUEST_ID")
      REFERENCES  "CRUMBS_REQUEST" ("ID") ON DELETE CASCADE ENABLE;
ALTER TABLE  "CRUMBS_ADDITIONAL_TOOLS" ADD CONSTRAINT "CRUMBS_ADDITIONAL_TOOLS_FK2" FOREIGN KEY ("TOOL_ID")
      REFERENCES  "CRUMBS_CATALOG_OF_TOOLS" ("ID") ON DELETE CASCADE ENABLE;
ALTER TABLE  "CRUMBS_CATALOG_OF_WORK" ADD CONSTRAINT "CRUMBS_CATALOG_OF_WORK_CON" FOREIGN KEY ("PARENT_ID")
      REFERENCES  "CRUMBS_CATALOG_OF_WORK" ("ID") ON DELETE CASCADE ENABLE;
ALTER TABLE  "CRUMBS_DATE_AND_TIME" ADD CONSTRAINT "CRUMBS_DATE_AND_TIME_CON" FOREIGN KEY ("REQUEST_ID")
      REFERENCES  "CRUMBS_REQUEST" ("ID") ENABLE;
ALTER TABLE  "CRUMBS_REQUEST_AND_WORK" ADD CONSTRAINT "CRUMBS_REQUEST_AND_WORK_FK" FOREIGN KEY ("REQUEST_ID")
      REFERENCES  "CRUMBS_REQUEST" ("ID") ENABLE;
ALTER TABLE  "CRUMBS_REQUEST_AND_WORK" ADD CONSTRAINT "CRUMBS_REQUEST_AND_WORK_FK2" FOREIGN KEY ("WORK_ID")
      REFERENCES  "CRUMBS_CATALOG_OF_WORK" ("ID") ENABLE;
ALTER TABLE  "CRUMBS_REQUEST_ASSIGN" ADD CONSTRAINT "CRUMBS_REQUEST_ASSIGN_FK" FOREIGN KEY ("REQUEST_ID")
      REFERENCES  "CRUMBS_REQUEST" ("ID") ON DELETE CASCADE ENABLE;
ALTER TABLE  "CRUMBS_REQUEST_ASSIGN" ADD CONSTRAINT "CRUMBS_REQUEST_ASSIGN_FK2" FOREIGN KEY ("USER_ID")
      REFERENCES  "CRUMBS_USER" ("USER_ID") ON DELETE CASCADE ENABLE;
ALTER TABLE  "CRUMBS_REQUEST" ADD CONSTRAINT "CRUMBS_REQUEST_CON" FOREIGN KEY ("CLIENT_ID")
      REFERENCES  "CRUMBS_CLIENT" ("ID") ON DELETE CASCADE ENABLE;
ALTER TABLE  "CRUMBS_REQUEST" ADD CONSTRAINT "CRUMBS_REQUEST_CON_STATE" FOREIGN KEY ("STATE_ID")
      REFERENCES  "CRUMBS_REQUESTS_STATE" ("ID") ON DELETE CASCADE ENABLE;
ALTER TABLE  "CRUMBS_USER" ADD CONSTRAINT "CRUMBS_USER_FK" FOREIGN KEY ("POSITION_ID")
      REFERENCES  "CRUMBS_POSITION" ("ID") ON DELETE CASCADE ENABLE;
ALTER TABLE  "CRUMBS_WORK_AND_TOOLS" ADD CONSTRAINT "CRUMBS_WORK_AND_TOOLS_FK3" FOREIGN KEY ("WORK_ID")
      REFERENCES  "CRUMBS_CATALOG_OF_WORK" ("ID") ON DELETE CASCADE ENABLE;
ALTER TABLE  "CRUMBS_WORK_AND_TOOLS" ADD CONSTRAINT "CRUMBS_WORK_AND_TOOLS_FK4" FOREIGN KEY ("TOOL_ID")
      REFERENCES  "CRUMBS_CATALOG_OF_TOOLS" ("ID") ON DELETE CASCADE ENABLE;
ALTER TABLE  "CRUMBS_PROCESS_HISTORY" ADD CONSTRAINT "PROCESS_HISTORY_FK2" FOREIGN KEY ("REQUEST_ID")
      REFERENCES  "CRUMBS_REQUEST" ("ID") ON DELETE CASCADE ENABLE;
ALTER TABLE  "CRUMBS_PROCESS_HISTORY" ADD CONSTRAINT "PROCESS_HISTORY_FK3" FOREIGN KEY ("RECIEVER_ID")
      REFERENCES  "CRUMBS_USER" ("USER_ID") ON DELETE CASCADE ENABLE;
ALTER TABLE  "CRUMBS_PROCESS_HISTORY" ADD CONSTRAINT "PROCESS_HISTORY_FK4" FOREIGN KEY ("SENDER_ID")
      REFERENCES  "CRUMBS_USER" ("USER_ID") ON DELETE CASCADE ENABLE;

CREATE SEQUENCE CLIENT_SEQUENCE START WITH 1 INCREMENT BY 1;
CREATE SEQUENCE REQUEST_SEQUENCE START WITH 1 INCREMENT BY 1;
CREATE SEQUENCE ADDITIONAL_TOOLS_SEQ START WITH 1 INCREMENT BY 1;
CREATE SEQUENCE CATALOG_OF_TOOLS_SEQ START WITH 1 INCREMENT BY 1;
CREATE SEQUENCE CATALOG_OF_WORK_SEQ START WITH 1 INCREMENT BY 1;
CREATE SEQUENCE DATE_AND_TIME_SEQ START WITH 1 INCREMENT BY 1;
CREATE SEQUENCE POSITION_SEQ START WITH 1 INCREMENT BY 1;
CREATE SEQUENCE PROCESS_HISTORY_SEQ START WITH 1 INCREMENT BY 1;
CREATE SEQUENCE REQUEST_AND_WORK_SEQ START WITH 1 INCREMENT BY 1;
CREATE SEQUENCE REQUEST_STATE_SEQ START WITH 1 INCREMENT BY 1;
CREATE SEQUENCE USER_SEQ START WITH 1 INCREMENT BY 1;

insert into Crumbs_position (ID, Name, Functional_requrements) Values(POSITION_SEQ.NEXTVAL,'Operator','Request creation and editing');
insert into Crumbs_position (ID, Name, Functional_requrements) Values(POSITION_SEQ.NEXTVAL,'Manager','Engineers timetable management');
insert into Crumbs_position (ID, Name, Functional_requrements) Values(POSITION_SEQ.NEXTVAL,'Engineer','Tasks execution');

insert into Crumbs_user(USER_ID, LOGIN, PASSWORD, POSITION_ID,phone, ADDITIONAL_INFO, SURNM_NM_SECONDNM) Values(USER_SEQ.NEXTVAL, 'operator1@test.ua', 'e1adc3949ba59abbe56e057f2f883e', 1,'1231231', '', 'Operator1' );
insert into Crumbs_user(USER_ID, LOGIN, PASSWORD, POSITION_ID,phone, ADDITIONAL_INFO, SURNM_NM_SECONDNM) Values(USER_SEQ.NEXTVAL, 'kiricheikov@gmail.com','e1adc3949ba59abbe56e057f2f883e', 1,'1231231', '', 'Operator2' );
insert into Crumbs_user(USER_ID, LOGIN, PASSWORD, POSITION_ID,phone, ADDITIONAL_INFO, SURNM_NM_SECONDNM) Values(USER_SEQ.NEXTVAL, 'operator3@test.ua', 'e1adc3949ba59abbe56e057f2f883e', 1,'1231231', '', 'Operator3' );
insert into Crumbs_user(USER_ID, LOGIN, PASSWORD, POSITION_ID,phone, ADDITIONAL_INFO, SURNM_NM_SECONDNM) Values(USER_SEQ.NEXTVAL, 'manager@test.ua', 'e1adc3949ba59abbe56e057f2f883e', 2,'1231231', '', 'Manager' );
insert into Crumbs_user(USER_ID, LOGIN, PASSWORD, POSITION_ID,phone, ADDITIONAL_INFO, SURNM_NM_SECONDNM) Values(USER_SEQ.NEXTVAL, 'crumbs.anastazi@gmail.com', 'e1adc3949ba59abbe56e057f2f883e', 3,'1231231', '', 'Engineer1' );
insert into Crumbs_user(USER_ID, LOGIN, PASSWORD, POSITION_ID,phone, ADDITIONAL_INFO, SURNM_NM_SECONDNM) Values(USER_SEQ.NEXTVAL, 'engineer2@test.ua', 'e1adc3949ba59abbe56e057f2f883e', 3,'1231231', '', 'Engineer2' );
insert into Crumbs_user(USER_ID, LOGIN, PASSWORD, POSITION_ID,phone, ADDITIONAL_INFO, SURNM_NM_SECONDNM) Values(USER_SEQ.NEXTVAL, 'engineer3@test.ua', 'e1adc3949ba59abbe56e057f2f883e', 3,'1231231', '', 'Engineer3' );
insert into Crumbs_user(USER_ID, LOGIN, PASSWORD, POSITION_ID,phone, ADDITIONAL_INFO, SURNM_NM_SECONDNM) Values(USER_SEQ.NEXTVAL, 'engineer4@test.ua', 'e1adc3949ba59abbe56e057f2f883e', 3,'1231231', '', 'Engineer4' );
insert into Crumbs_user(USER_ID, LOGIN, PASSWORD, POSITION_ID,phone, ADDITIONAL_INFO, SURNM_NM_SECONDNM) Values(USER_SEQ.NEXTVAL, 'engineer5@test.ua', 'e1adc3949ba59abbe56e057f2f883e', 3,'1231231', '', 'Engineer5' );

insert into Crumbs_client (ID,NAME,ADRESS,MAIL) values (CLIENT_SEQUENCE.NEXTVAL,'Vasil Poprivse','vul. Petljuri, 18/79','zanashih@gmail.com');
insert into Crumbs_client (ID,NAME,ADRESS,MAIL) values (CLIENT_SEQUENCE.NEXTVAL,'Oleksandr','vul. Vasilja Natshheserce, 29/36','vanya@gmail.com');
insert into Crumbs_client (ID,NAME,ADRESS,MAIL) values (CLIENT_SEQUENCE.NEXTVAL,'Maksim Vikotikorito','vul. Zaliznichnoi gildii, 15/24','korito@gmail.com');
insert into Crumbs_client (ID,NAME,ADRESS,MAIL) values (CLIENT_SEQUENCE.NEXTVAL,'Georgij Zubzazub','vul. Odesko-Evrejska, 24/24','iamsocool@gmail.com');
insert into Crumbs_client (ID,NAME,ADRESS,MAIL) values (CLIENT_SEQUENCE.NEXTVAL,'Taras Kvas','vul. Prirodno-promislovo, 26','dobrinya@mail.ru');
insert into Crumbs_client (ID,NAME,ADRESS,MAIL) values (CLIENT_SEQUENCE.NEXTVAL,'Ostap Natshheserce','vul. Velikih Pobrikenkiv, 12/12','natshe@gmail.com');
insert into Crumbs_client (ID,NAME,ADRESS,MAIL) values (CLIENT_SEQUENCE.NEXTVAL,'Georgij Nekotibochku','vul. Vagonobudivna, 14/5','watsup@gmail.com');
insert into Crumbs_client (ID,NAME,ADRESS,MAIL) values (CLIENT_SEQUENCE.NEXTVAL,'Vasil Hvirtka','vul Vitrjana, 17','windows@gmail.com');
insert into Crumbs_client (ID,NAME,ADRESS,MAIL) values (CLIENT_SEQUENCE.NEXTVAL,'Ganna Kanhfeta-BonDju','vul Cukerna, misto Leva, Ploshha rinok, 32','bonn@gmail.com');
insert into Crumbs_client (ID,NAME,ADRESS,MAIL) values (CLIENT_SEQUENCE.NEXTVAL,'Olga Vsebudedobre','vul. Evrejsko-evropejska, 56','whatislovebabydonthurtmenomore@gmail.com');

insert into crumbs_catalog_of_work (id,is_parent,parent_id,runtime,work_description,workname,is_delete) values (CATALOG_OF_WORK_SEQ.NEXTVAL,'1','','','installing smth','install',0);
insert into crumbs_catalog_of_work (id,is_parent,parent_id,runtime,work_description,workname,is_delete) values (CATALOG_OF_WORK_SEQ.NEXTVAL,'1','','','uninstalling of differen things','uninstall',0);
insert into crumbs_catalog_of_work (id,is_parent,parent_id,runtime,work_description,workname,is_delete) values (CATALOG_OF_WORK_SEQ.NEXTVAL,'0','1','30','installing of the windows','windows install',0);
insert into crumbs_catalog_of_work (id,is_parent,parent_id,runtime,work_description,workname,is_delete) values (CATALOG_OF_WORK_SEQ.NEXTVAL,'0','1','20','installing of the linux','linux install',0);
insert into crumbs_catalog_of_work (id,is_parent,parent_id,runtime,work_description,workname,is_delete) values (CATALOG_OF_WORK_SEQ.NEXTVAL,'0','1','15','installing of the drivers','drivers install',0);
insert into crumbs_catalog_of_work (id,is_parent,parent_id,runtime,work_description,workname,is_delete) values (CATALOG_OF_WORK_SEQ.NEXTVAL,'0','1','30','installing of the router','router install',0);
insert into crumbs_catalog_of_work (id,is_parent,parent_id,runtime,work_description,workname,is_delete) values (CATALOG_OF_WORK_SEQ.NEXTVAL,'0','1','50','installing of the computer','computer installation and configuration',0);
insert into crumbs_catalog_of_work (id,is_parent,parent_id,runtime,work_description,workname,is_delete) values (CATALOG_OF_WORK_SEQ.NEXTVAL,'0','2','15','uninstalling of the router','router uninstall',0);
insert into crumbs_catalog_of_work (id,is_parent,parent_id,runtime,work_description,workname,is_delete) values (CATALOG_OF_WORK_SEQ.NEXTVAL,'0','2','20','uninstalling of the computer','computer uninstallation',0);
insert into crumbs_catalog_of_work (id,is_parent,parent_id,runtime,work_description,workname,is_delete) values (CATALOG_OF_WORK_SEQ.NEXTVAL,'0','2','10','internet wires cutting off','cutting off the internet cables',0);
insert into crumbs_catalog_of_work (id,is_parent,parent_id,runtime,work_description,workname,is_delete) values (CATALOG_OF_WORK_SEQ.NEXTVAL,'0','1','10','pulling internet cables to the client per meter','wires pulling',0);
insert into crumbs_catalog_of_work (id,is_parent,parent_id,runtime,work_description,workname,is_delete) values (CATALOG_OF_WORK_SEQ.NEXTVAL,'1','2','','uninstalling of differen routers','uninstall routers',0);
insert into crumbs_catalog_of_work (id,is_parent,parent_id,runtime,work_description,workname,is_delete) values (CATALOG_OF_WORK_SEQ.NEXTVAL,'0','12','30','uninstalling of cisco routers','uninstall cisco',0);
insert into crumbs_catalog_of_work (id,is_parent,parent_id,runtime,work_description,workname,is_delete) values (CATALOG_OF_WORK_SEQ.NEXTVAL,'0','12','20','uninstalling of d-link routers','uninstall d-link',0);

insert into crumbs_catalog_of_tools(id,name,tools_description,is_delete) values (CATALOG_OF_TOOLS_SEQ.NEXTVAL,'head','to have mind',0);
insert into crumbs_catalog_of_tools(id,name,tools_description,is_delete) values (CATALOG_OF_TOOLS_SEQ.NEXTVAL,'hands','to be straight',0);
insert into crumbs_catalog_of_tools(id,name,tools_description,is_delete) values (CATALOG_OF_TOOLS_SEQ.NEXTVAL,'mind','to think',0);
insert into crumbs_catalog_of_tools(id,name,tools_description,is_delete) values (CATALOG_OF_TOOLS_SEQ.NEXTVAL,'wires','to give people the internet',0);
insert into crumbs_catalog_of_tools(id,name,tools_description,is_delete) values (CATALOG_OF_TOOLS_SEQ.NEXTVAL,'Linemans pliers','to work with',0);
insert into crumbs_catalog_of_tools(id,name,tools_description,is_delete) values (CATALOG_OF_TOOLS_SEQ.NEXTVAL,'Screwdriver','to screw',0);
insert into crumbs_catalog_of_tools(id,name,tools_description,is_delete) values (CATALOG_OF_TOOLS_SEQ.NEXTVAL,'TOOL 7','description for TOOL number 7',0);
insert into crumbs_catalog_of_tools(id,name,tools_description,is_delete) values (CATALOG_OF_TOOLS_SEQ.NEXTVAL,'TOOL 8','description for TOOL number 8',0);
insert into crumbs_catalog_of_tools(id,name,tools_description,is_delete) values (CATALOG_OF_TOOLS_SEQ.NEXTVAL,'TOOL 9','description for TOOL number 9',0);
insert into crumbs_catalog_of_tools(id,name,tools_description,is_delete) values (CATALOG_OF_TOOLS_SEQ.NEXTVAL,'TOOL 10','description for TOOL number 10',0);
insert into crumbs_catalog_of_tools(id,name,tools_description,is_delete) values (CATALOG_OF_TOOLS_SEQ.NEXTVAL,'TOOL 11','description for TOOL number 11',0);
insert into crumbs_catalog_of_tools(id,name,tools_description,is_delete) values (CATALOG_OF_TOOLS_SEQ.NEXTVAL,'TOOL 12','description for TOOL number 12',0);
insert into crumbs_catalog_of_tools(id,name,tools_description,is_delete) values (CATALOG_OF_TOOLS_SEQ.NEXTVAL,'TOOL 13','description for TOOL number 13',0);
insert into crumbs_catalog_of_tools(id,name,tools_description,is_delete) values (CATALOG_OF_TOOLS_SEQ.NEXTVAL,'TOOL 14','description for TOOL number 14',0);
insert into crumbs_catalog_of_tools(id,name,tools_description,is_delete) values (CATALOG_OF_TOOLS_SEQ.NEXTVAL,'TOOL 15','description for TOOL number 15',0);
insert into crumbs_catalog_of_tools(id,name,tools_description,is_delete) values (CATALOG_OF_TOOLS_SEQ.NEXTVAL,'TOOL 16','description for TOOL number 16',0);
insert into crumbs_catalog_of_tools(id,name,tools_description,is_delete) values (CATALOG_OF_TOOLS_SEQ.NEXTVAL,'TOOL 17','description for TOOL number 17',0);
insert into crumbs_catalog_of_tools(id,name,tools_description,is_delete) values (CATALOG_OF_TOOLS_SEQ.NEXTVAL,'TOOL 18','description for TOOL number 18',0);
insert into crumbs_catalog_of_tools(id,name,tools_description,is_delete) values (CATALOG_OF_TOOLS_SEQ.NEXTVAL,'TOOL 19','description for TOOL number 19',0);

insert into crumbs_work_and_tools(tool_id,work_id) values ('14','6');
insert into crumbs_work_and_tools(tool_id,work_id) values ('10','7');
insert into crumbs_work_and_tools(tool_id,work_id) values ('7','4');
insert into crumbs_work_and_tools(tool_id,work_id) values ('17','11');
insert into crumbs_work_and_tools(tool_id,work_id) values ('19','4');
insert into crumbs_work_and_tools(tool_id,work_id) values ('16','7');
insert into crumbs_work_and_tools(tool_id,work_id) values ('4','9');
insert into crumbs_work_and_tools(tool_id,work_id) values ('5','8');
insert into crumbs_work_and_tools(tool_id,work_id) values ('6','10');
insert into crumbs_work_and_tools(tool_id,work_id) values ('19','8');
insert into crumbs_work_and_tools(tool_id,work_id) values ('11','11');
insert into crumbs_work_and_tools(tool_id,work_id) values ('6','4');
insert into crumbs_work_and_tools(tool_id,work_id) values ('1','11');
insert into crumbs_work_and_tools(tool_id,work_id) values ('17','10');
insert into crumbs_work_and_tools(tool_id,work_id) values ('7','9');
insert into crumbs_work_and_tools(tool_id,work_id) values ('3','3');
insert into crumbs_work_and_tools(tool_id,work_id) values ('10','3');
insert into crumbs_work_and_tools(tool_id,work_id) values ('17','5');
insert into crumbs_work_and_tools(tool_id,work_id) values ('14','6');
insert into crumbs_work_and_tools(tool_id,work_id) values ('2','5');
insert into crumbs_work_and_tools(tool_id,work_id) values ('12','9');
insert into crumbs_work_and_tools(tool_id,work_id) values ('8','8');
insert into crumbs_work_and_tools(tool_id,work_id) values ('12','6');
insert into crumbs_work_and_tools(tool_id,work_id) values ('4','10');
insert into crumbs_work_and_tools(tool_id,work_id) values ('4','3');
insert into crumbs_work_and_tools(tool_id,work_id) values ('15','4');
insert into crumbs_work_and_tools(tool_id,work_id) values ('16','3');
insert into crumbs_work_and_tools(tool_id,work_id) values ('9','9');
insert into crumbs_work_and_tools(tool_id,work_id) values ('15','8');
insert into crumbs_work_and_tools(tool_id,work_id) values ('10','6');
insert into crumbs_work_and_tools(tool_id,work_id) values ('3','5');
insert into crumbs_work_and_tools(tool_id,work_id) values ('2','3');
insert into crumbs_work_and_tools(tool_id,work_id) values ('14','4');
insert into crumbs_work_and_tools(tool_id,work_id) values ('17','3');
insert into crumbs_work_and_tools(tool_id,work_id) values ('10','9');
insert into crumbs_work_and_tools(tool_id,work_id) values ('19','6');
insert into crumbs_work_and_tools(tool_id,work_id) values ('11','6');
insert into crumbs_work_and_tools(tool_id,work_id) values ('3','10');
insert into crumbs_work_and_tools(tool_id,work_id) values ('12','9');
insert into crumbs_work_and_tools(tool_id,work_id) values ('18','4');
insert into crumbs_work_and_tools(tool_id,work_id) values ('16','5');

insert into crumbs_requests_state(id,state) values(REQUEST_STATE_SEQ.NEXTVAL,'New');
insert into crumbs_requests_state(id,state) values(REQUEST_STATE_SEQ.NEXTVAL,'In progress');
insert into crumbs_requests_state(id,state) values(REQUEST_STATE_SEQ.NEXTVAL,'Assessed');
insert into crumbs_requests_state(id,state) values(REQUEST_STATE_SEQ.NEXTVAL,'Need more info');
insert into crumbs_requests_state(id,state) values(REQUEST_STATE_SEQ.NEXTVAL,'Rejected');
insert into crumbs_requests_state(id,state) values(REQUEST_STATE_SEQ.NEXTVAL,'Closed');

insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('15/07/2012 11:00','DD/MM/YYYY HH24:MI'),'3','1','request info number 1','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('10/01/2012 11:00','DD/MM/YYYY HH24:MI'),'3','6','request info number 2','60');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('27/02/2012 11:00','DD/MM/YYYY HH24:MI'),'4','1','request info number 3','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('19/01/2012 11:00','DD/MM/YYYY HH24:MI'),'10','2','request info number 4','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('23/02/2012 11:00','DD/MM/YYYY HH24:MI'),'2','5','request info number 5','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('26/04/2012 11:00','DD/MM/YYYY HH24:MI'),'5','6','request info number 6','40');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('10/11/2012 11:00','DD/MM/YYYY HH24:MI'),'7','4','request info number 7','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('01/02/2012 11:00','DD/MM/YYYY HH24:MI'),'6','2','request info number 8','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('12/04/2012 11:00','DD/MM/YYYY HH24:MI'),'7','2','request info number 9','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('10/08/2012 11:00','DD/MM/YYYY HH24:MI'),'6','3','request info number 10','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('07/09/2012 11:00','DD/MM/YYYY HH24:MI'),'3','4','request info number 11','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('28/05/2012 11:00','DD/MM/YYYY HH24:MI'),'8','4','request info number 12','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('16/05/2012 11:00','DD/MM/YYYY HH24:MI'),'4','1','request info number 13','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('16/02/2012 11:00','DD/MM/YYYY HH24:MI'),'5','5','request info number 14','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('17/04/2012 11:00','DD/MM/YYYY HH24:MI'),'5','1','request info number 15','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('11/12/2012 11:00','DD/MM/YYYY HH24:MI'),'3','2','request info number 16','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('14/08/2012 11:00','DD/MM/YYYY HH24:MI'),'5','5','request info number 17','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('17/01/2012 11:00','DD/MM/YYYY HH24:MI'),'5','3','request info number 18','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('23/01/2012 11:00','DD/MM/YYYY HH24:MI'),'5','1','request info number 19','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('16/02/2012 11:00','DD/MM/YYYY HH24:MI'),'9','1','request info number 20','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('10/11/2012 11:00','DD/MM/YYYY HH24:MI'),'5','6','request info number 21','60');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('25/01/2012 11:00','DD/MM/YYYY HH24:MI'),'4','4','request info number 22','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('28/07/2012 11:00','DD/MM/YYYY HH24:MI'),'7','3','request info number 23','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('26/10/2012 11:00','DD/MM/YYYY HH24:MI'),'8','3','request info number 24','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('12/04/2012 11:00','DD/MM/YYYY HH24:MI'),'3','2','request info number 25','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('20/10/2012 11:00','DD/MM/YYYY HH24:MI'),'6','5','request info number 26','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('23/02/2012 11:00','DD/MM/YYYY HH24:MI'),'6','2','request info number 27','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('04/09/2012 11:00','DD/MM/YYYY HH24:MI'),'6','1','request info number 28','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('19/03/2012 11:00','DD/MM/YYYY HH24:MI'),'5','4','request info number 29','');
insert into crumbs_request(id,date_of_creation,client_id,state_id,request_info, actual_time_of_work) values(REQUEST_SEQUENCE.NEXTVAL,TO_date('01/05/2012 11:00','DD/MM/YYYY HH24:MI'),'9','5','request info number 30','');


insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'1','3','1');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'1','5','4');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'2','4','2');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'3','5','3');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'4','6','2');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'5','7','3');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'6','8','2');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'7','9','4');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'8','10','1');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'8','4','3');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'9','11','10');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'10','11','5');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'11','10','3');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'12','9','2');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'13','8','4');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'14','7','1');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'15','6','3');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'16','5','4');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'17','4','5');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'18','3','6');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'19','3','1');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'20','4','3');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'21','5','5');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'22','6','3');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'23','7','4');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'24','8','6');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'25','9','7');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'26','10','8');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'27','11','4');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'28','11','3');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'28','7','3');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'29','9','3');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'30','10','1');
insert into crumbs_request_and_work(id,request_id,work_id,amount_of_work) values(REQUEST_AND_WORK_SEQ.NEXTVAL,'30','11','12');


insert into crumbs_additional_tools(id,request_id,tool_id,amount) values(ADDITIONAL_TOOLS_SEQ.NEXTVAL,'2','7','2');
insert into crumbs_additional_tools(id,request_id,tool_id,amount) values(ADDITIONAL_TOOLS_SEQ.NEXTVAL,'2','19','1');
insert into crumbs_additional_tools(id,request_id,tool_id,amount) values(ADDITIONAL_TOOLS_SEQ.NEXTVAL,'6','19','2');
insert into crumbs_additional_tools(id,request_id,tool_id,amount) values(ADDITIONAL_TOOLS_SEQ.NEXTVAL,'6','15','4');
insert into crumbs_additional_tools(id,request_id,tool_id,amount) values(ADDITIONAL_TOOLS_SEQ.NEXTVAL,'21','16','3');


insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,30,to_date('10/04/2013 10:00','DD/MM/YYYY HH24:MI'),to_date('10/04/2013 16:00','DD/MM/YYYY HH24:MI'),'','');
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,29,to_date('07/12/2013 10:00','DD/MM/YYYY HH24:MI'),to_date('07/12/2013 17:00','DD/MM/YYYY HH24:MI'),to_date('07/12/2013 10:00','DD/MM/YYYY HH24:MI'),to_date('07/12/2013 11:00','DD/MM/YYYY HH24:MI'));
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,28,to_date('14/06/2013 10:00','DD/MM/YYYY HH24:MI'),to_date('04/06/2013 18:00','DD/MM/YYYY HH24:MI'),'','');
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,27,to_date('08/10/2013 10:00','DD/MM/YYYY HH24:MI'),to_date('08/10/2013 15:00','DD/MM/YYYY HH24:MI'),to_date('08/10/2013 14:00','DD/MM/YYYY HH24:MI'),to_date('08/10/2013 15:00','DD/MM/YYYY HH24:MI'));
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,26,to_date('10/08/2013 11:00','DD/MM/YYYY HH24:MI'),to_date('10/08/2013 17:00','DD/MM/YYYY HH24:MI'),'','');
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,25,to_date('08/07/2013 10:00','DD/MM/YYYY HH24:MI'),to_date('08/07/2013 17:00','DD/MM/YYYY HH24:MI'),'','');
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,24,to_date('12/12/2013 12:00','DD/MM/YYYY HH24:MI'),to_date('12/12/2013 16:00','DD/MM/YYYY HH24:MI'),to_date('12/12/2013 13:00','DD/MM/YYYY HH24:MI'),to_date('12/12/2013 15:00','DD/MM/YYYY HH24:MI'));
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,23,to_date('12/07/2013 11:00','DD/MM/YYYY HH24:MI'),to_date('12/07/2013 18:00','DD/MM/YYYY HH24:MI'),to_date('12/07/2013 12:00','DD/MM/YYYY HH24:MI'),to_date('12/07/2013 16:00','DD/MM/YYYY HH24:MI'));
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,22,to_date('07/08/2013 12:00','DD/MM/YYYY HH24:MI'),to_date('07/08/2013 15:00','DD/MM/YYYY HH24:MI'),to_date('07/08/2013 12:00','DD/MM/YYYY HH24:MI'),to_date('07/08/2013 14:00','DD/MM/YYYY HH24:MI'));
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,21,to_date('01/09/2013 10:00','DD/MM/YYYY HH24:MI'),to_date('01/09/2013 18:00','DD/MM/YYYY HH24:MI'),to_date('01/09/2013 16:00','DD/MM/YYYY HH24:MI'),to_date('01/09/2013 18:00','DD/MM/YYYY HH24:MI'));
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,20,to_date('13/10/2013 11:00','DD/MM/YYYY HH24:MI'),to_date('13/10/2013 13:00','DD/MM/YYYY HH24:MI'),'','');
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,19,to_date('10/05/2013 10:00','DD/MM/YYYY HH24:MI'),to_date('10/05/2013 16:00','DD/MM/YYYY HH24:MI'),'','');
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,18,to_date('12/07/2013 10:00','DD/MM/YYYY HH24:MI'),to_date('12/07/2013 16:00','DD/MM/YYYY HH24:MI'),to_date('12/07/2013 11:00','DD/MM/YYYY HH24:MI'),to_date('12/07/2013 14:00','DD/MM/YYYY HH24:MI'));
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,17,to_date('09/08/2013 10:00','DD/MM/YYYY HH24:MI'),to_date('09/08/2013 16:00','DD/MM/YYYY HH24:MI'),'','');
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,16,to_date('05/05/2013 11:00','DD/MM/YYYY HH24:MI'),to_date('05/05/2013 14:00','DD/MM/YYYY HH24:MI'),to_date('05/05/2013 13:00','DD/MM/YYYY HH24:MI'),to_date('05/05/2013 14:00','DD/MM/YYYY HH24:MI'));
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,15,to_date('23/04/2013 12:00','DD/MM/YYYY HH24:MI'),to_date('23/04/2013 16:00','DD/MM/YYYY HH24:MI'),'','');
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,14,to_date('04/10/2013 12:00','DD/MM/YYYY HH24:MI'),to_date('04/10/2013 14:00','DD/MM/YYYY HH24:MI'),'','');
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,13,to_date('13/12/2013 13:00','DD/MM/YYYY HH24:MI'),to_date('13/12/2013 17:00','DD/MM/YYYY HH24:MI'),'','');
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,12,to_date('30/04/2013 13:00','DD/MM/YYYY HH24:MI'),to_date('30/04/2013 17:00','DD/MM/YYYY HH24:MI'),to_date('30/04/2013 14:00','DD/MM/YYYY HH24:MI'),to_date('30/04/2013 15:00','DD/MM/YYYY HH24:MI'));
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,11,to_date('09/09/2013 12:00','DD/MM/YYYY HH24:MI'),to_date('09/09/2013 14:00','DD/MM/YYYY HH24:MI'),to_date('09/09/2013 12:00','DD/MM/YYYY HH24:MI'),to_date('09/09/2013 13:00','DD/MM/YYYY HH24:MI'));
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,10,to_date('10/10/2013 10:00','DD/MM/YYYY HH24:MI'),to_date('10/10/2013 15:00','DD/MM/YYYY HH24:MI'),to_date('10/10/2013 14:00','DD/MM/YYYY HH24:MI'),to_date('10/10/2013 15:00','DD/MM/YYYY HH24:MI'));
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,9,to_date('11/04/2013 10:00','DD/MM/YYYY HH24:MI'),to_date('11/04/2013 15:00','DD/MM/YYYY HH24:MI'),'','');
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,8,to_date('12/07/2013 11:00','DD/MM/YYYY HH24:MI'),to_date('12/07/2013 15:00','DD/MM/YYYY HH24:MI'),to_date('12/07/2013 11:00','DD/MM/YYYY HH24:MI'),to_date('12/07/2013 13:00','DD/MM/YYYY HH24:MI'));
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,7,to_date('11/08/2013 11:00','DD/MM/YYYY HH24:MI'),to_date('11/08/2013 17:00','DD/MM/YYYY HH24:MI'),to_date('11/08/2013 15:00','DD/MM/YYYY HH24:MI'),to_date('11/08/2013 17:00','DD/MM/YYYY HH24:MI'));
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,6,to_date('10/07/2013 11:00','DD/MM/YYYY HH24:MI'),to_date('10/07/2013 14:00','DD/MM/YYYY HH24:MI'),to_date('10/07/2013 12:00','DD/MM/YYYY HH24:MI'),to_date('10/07/2013 13:00','DD/MM/YYYY HH24:MI'));
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,5,to_date('01/07/2013 11:00','DD/MM/YYYY HH24:MI'),to_date('01/07/2013 18:00','DD/MM/YYYY HH24:MI'),'','');
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,4,to_date('05/09/2013 10:00','DD/MM/YYYY HH24:MI'),to_date('05/09/2013 12:00','DD/MM/YYYY HH24:MI'),'','');
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,3,to_date('02/10/2013 12:00','DD/MM/YYYY HH24:MI'),to_date('02/10/2013 16:00','DD/MM/YYYY HH24:MI'),'','');
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,2,to_date('13/10/2013 11:00','DD/MM/YYYY HH24:MI'),to_date('13/10/2013 13:00','DD/MM/YYYY HH24:MI'),to_date('13/10/2013 11:00','DD/MM/YYYY HH24:MI'),to_date('13/10/2013 12:00','DD/MM/YYYY HH24:MI'));
insert into crumbs_date_and_time (id,request_id,date_begin,date_end,assigned_time_begin,assigned_time_end) values (DATE_AND_TIME_SEQ.NEXTVAL,1,to_date('13/11/2013 13:00','DD/MM/YYYY HH24:MI'),to_date('13/11/2013 18:00','DD/MM/YYYY HH24:MI'),'','');

insert into CRUMBS_REQUEST_ASSIGN(request_id,user_id) values(2,5);
insert into CRUMBS_REQUEST_ASSIGN(request_id,user_id) values(6,6);
insert into CRUMBS_REQUEST_ASSIGN(request_id,user_id) values(7,7);
insert into CRUMBS_REQUEST_ASSIGN(request_id,user_id) values(8,8);
insert into CRUMBS_REQUEST_ASSIGN(request_id,user_id) values(10,5);
insert into CRUMBS_REQUEST_ASSIGN(request_id,user_id) values(11,6);
insert into CRUMBS_REQUEST_ASSIGN(request_id,user_id) values(12,8);
insert into CRUMBS_REQUEST_ASSIGN(request_id,user_id) values(16,7);
insert into CRUMBS_REQUEST_ASSIGN(request_id,user_id) values(18,7);
insert into CRUMBS_REQUEST_ASSIGN(request_id,user_id) values(21,9);
insert into CRUMBS_REQUEST_ASSIGN(request_id,user_id) values(22,5);
insert into CRUMBS_REQUEST_ASSIGN(request_id,user_id) values(23,6);
insert into CRUMBS_REQUEST_ASSIGN(request_id,user_id) values(24,7);
insert into CRUMBS_REQUEST_ASSIGN(request_id,user_id) values(27,9);
insert into CRUMBS_REQUEST_ASSIGN(request_id,user_id) values(29,5);

insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('15/07/2012 11:00','DD/MM/YYYY HH24:MI'),1,'',1,1);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('10/01/2012 11:00','DD/MM/YYYY HH24:MI'),2,'',2,2);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('10/01/2012 11:20','DD/MM/YYYY HH24:MI'),2,'',4,2);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('10/01/2012 11:45','DD/MM/YYYY HH24:MI'),2,'take it do it',5,4);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('12/01/2012 19:00','DD/MM/YYYY HH24:MI'),2,'it was wonderfull',5,5);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('27/02/2012 11:00','DD/MM/YYYY HH24:MI'),3,'',3,3);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('19/01/2012 11:00','DD/MM/YYYY HH24:MI'),4,'',1,1);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('19/01/2012 11:23','DD/MM/YYYY HH24:MI'),4,'',4,1);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('23/02/2012 11:45','DD/MM/YYYY HH24:MI'),5,'',2,2);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('23/02/2012 13:40','DD/MM/YYYY HH24:MI'),5,'',4,2);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('26/04/2012 13:56','DD/MM/YYYY HH24:MI'),6,'',3,3);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('26/04/2012 14:12','DD/MM/YYYY HH24:MI'),6,'',4,3);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('26/04/2012 14:56','DD/MM/YYYY HH24:MI'),6,'go',6,4);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('27/04/2012 15:56','DD/MM/YYYY HH24:MI'),6,'done',6,6);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('10/11/2012 15:56','DD/MM/YYYY HH24:MI'),7,'',1,1);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('11/11/2012 16:43','DD/MM/YYYY HH24:MI'),7,'',4,1);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('11/11/2012 16:58','DD/MM/YYYY HH24:MI'),7,'yeah?',7,4);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('11/11/2012 18:00','DD/MM/YYYY HH24:MI'),7,'yeah?',4,7);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('01/02/2012 16:58','DD/MM/YYYY HH24:MI'),8,'',2,2);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('02/02/2012 10:43','DD/MM/YYYY HH24:MI'),8,'',4,2);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('12/04/2012 10:43','DD/MM/YYYY HH24:MI'),9,'',1,1);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('12/04/2012 11:50','DD/MM/YYYY HH24:MI'),9,'',4,1);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('10/08/2012 11:50','DD/MM/YYYY HH24:MI'),10,'',2,2);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('10/08/2012 12:00','DD/MM/YYYY HH24:MI'),10,'',4,2);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('10/08/2012 11:50','DD/MM/YYYY HH24:MI'),10,'it a good job',5,4);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('7/09/2012 11:50','DD/MM/YYYY HH24:MI'),11,'',3,3);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('7/09/2012 15:00','DD/MM/YYYY HH24:MI'),11,'',4,3);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('7/09/2012 15:00','DD/MM/YYYY HH24:MI'),11,'be carefull',6,4);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('23/02/2012 13:56','DD/MM/YYYY HH24:MI'),5,'smth is wrong',2,4);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('11/11/2012 16:56','DD/MM/YYYY HH24:MI'),7,'yeah',7,4);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('28/05/2012 16:56','DD/MM/YYYY HH24:MI'),12,'',1,1);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('28/05/2012 16:57','DD/MM/YYYY HH24:MI'),12,'',4,1);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('28/05/2012 16:58','DD/MM/YYYY HH24:MI'),12,'asap',8,4);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('28/05/2012 16:59','DD/MM/YYYY HH24:MI'),12,'are you sure?',4,8);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('16/05/2012 16:59','DD/MM/YYYY HH24:MI'),13,'',2,2);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('16/02/2012 16:59','DD/MM/YYYY HH24:MI'),14,'',2,2);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('16/02/2012 16:59','DD/MM/YYYY HH24:MI'),14,'',4,2);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('16/02/2012 16:59','DD/MM/YYYY HH24:MI'),14,'task is not clear',2,4);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('17/04/2012 16:59','DD/MM/YYYY HH24:MI'),15,'',1,1);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('11/12/2012 17:09','DD/MM/YYYY HH24:MI'),16,'',2,2);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('11/12/2012 17:11','DD/MM/YYYY HH24:MI'),16,'',4,2);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('14/08/2012 11:00','DD/MM/YYYY HH24:MI'),17,'',1,1);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('14/08/2012 11:01','DD/MM/YYYY HH24:MI'),17,'',4,1);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('14/08/2012 11:02','DD/MM/YYYY HH24:MI'),17,'how?',1,4);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('17/01/2012 11:00','DD/MM/YYYY HH24:MI'),18,'',3,3);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('17/01/2012 11:00','DD/MM/YYYY HH24:MI'),18,'',4,3);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('17/01/2012 11:00','DD/MM/YYYY HH24:MI'),18,'you got a job',7,4);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('23/01/2012 11:00','DD/MM/YYYY HH24:MI'),19,'',3,3);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('16/02/2012 11:00','DD/MM/YYYY HH24:MI'),20,'',2,2);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('10/02/2012 11:00','DD/MM/YYYY HH24:MI'),21,'',4,2);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('10/02/2012 11:11','DD/MM/YYYY HH24:MI'),21,'chalenge',9,4);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('10/02/2012 11:13','DD/MM/YYYY HH24:MI'),21,'closed',9,9);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('25/01/2012 11:00','DD/MM/YYYY HH24:MI'),22,'',2,2);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('25/01/2012 11:00','DD/MM/YYYY HH24:MI'),22,'',4,2);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('25/01/2012 11:00','DD/MM/YYYY HH24:MI'),22,'',5,4);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('25/01/2012 12:00','DD/MM/YYYY HH24:MI'),22,'I need more info',4,5);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('28/07/2012 12:00','DD/MM/YYYY HH24:MI'),23,'',1,1);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('28/07/2012 12:5','DD/MM/YYYY HH24:MI'),23,'',4,1);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('28/07/2012 12:12','DD/MM/YYYY HH24:MI'),23,'ulala',6,4);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('26/10/2012 12:12','DD/MM/YYYY HH24:MI'),24,'',2,2);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('26/10/2012 12:04','DD/MM/YYYY HH24:MI'),24,'',4,2);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('26/10/2012 12:04','DD/MM/YYYY HH24:MI'),24,'gogogo',7,4);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('12/04/2012 12:04','DD/MM/YYYY HH24:MI'),25,'',1,1);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('12/04/2012 12:05','DD/MM/YYYY HH24:MI'),25,'',4,1);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('20/10/2012 12:10','DD/MM/YYYY HH24:MI'),26,'',2,2);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('20/10/2012 12:10','DD/MM/YYYY HH24:MI'),26,'',4,2);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('20/10/2012 12:10','DD/MM/YYYY HH24:MI'),26,'what do you want',2,4);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('23/02/2012 12:10','DD/MM/YYYY HH24:MI'),27,'',3,3);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('23/02/2012 12:11','DD/MM/YYYY HH24:MI'),27,'',4,3);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('04/09/2012 11:00','DD/MM/YYYY HH24:MI'),28,'',3,3);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('19/03/2012 11:00','DD/MM/YYYY HH24:MI'),29,'',2,2);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('19/03/2012 11:40','DD/MM/YYYY HH24:MI'),29,'',4,2);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('19/03/2012 11:43','DD/MM/YYYY HH24:MI'),29,'how about this?',5,4);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('19/03/2012 11:55','DD/MM/YYYY HH24:MI'),29,'need more info',4,5);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('01/05/2012 11:00','DD/MM/YYYY HH24:MI'),30,'',3,3);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('01/05/2012 11:00','DD/MM/YYYY HH24:MI'),30,'',4,3);
insert into CRUMBS_PROCESS_HISTORY(id,fixed_date,request_id,comment_text,reciever_id,sender_id) values(PROCESS_HISTORY_SEQ.NEXTVAL,TO_date('01/05/2012 11:22','DD/MM/YYYY HH24:MI'),30,'I reject it',3,4);